<html xmlns="http://www.w3.org/1999/xhtml" lang="en">

<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title>MySQL 8.0 Reference Manual</title>
  <link rel="stylesheet" href="mvl.css" type="text/css" />
  <meta name="generator" content="DocBook XSL Stylesheets + chunker.py v1.9.2" />
  <link rel="start" href="index.html" title="{book-title}" />
  <link rel="up" href="" title="" />
  <link rel="prev" href="" title="" />
  <link rel="next" href="preface.html" title=" Preface and Legal Notices" />
</head>

<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
  <div class="navheader">
    <table width="100%" summary="Navigation header">
      <tr>
        <th colspan="3" align="center">MySQL 8.0
          <span class="title">参考手册</span>
        </th>
      </tr>
      <tr>
        <td width="20%" align="left"> </td>
        <th width="60%" align="center"></th>
        <td width="20%" align="right">
          <a accesskey="n" href="preface.html">Next</a>
        </td>
      </tr>
    </table>
    <hr>
  </div>
  <div lang="en" class="book">

    <div class="titlepage">
      <div>
        <div>
          <h1 class="title">
            <a name="refman-8-0"></a>MySQL 8.0 参考手册</h1>
        </div>
        <div>

          <div class="abstract">
            <p class="title">摘要</p>
            <p>
              这是MySQL™参考手册。 它记录了MySQL 8.0到8.0.13。 它可能包括尚未发布的MySQL版本的功能文档。 有关哪些版本已发布的信息, 点击这里
              <a class="ulink" href="http://dev.mysql.com/doc/relnotes/mysql/8.0/en/" target="_top">MySQL 8.0 Release Notes</a>.
            </p>
            <p>
              MySQL集群目前在MySQL 8.0中不受支持。 有关MySQL Cluster的信息, 请查看这里
              <a class="ulink" href="http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster.html" target="_top">MySQL NDB Cluster 7.5 and NDB Cluster 7.6</a>.
            </p>
            <p>
              <b>MySQL 8.0 特性. </b>
              本手册介绍了MySQL 8.0的每个版本中未包含的功能; 这些功能可能不包含在授权给您的MySQL 8.0的版本中。 如果您对MySQL 8.0版本中包含的功能有任何疑问，请参阅MySQL 8.0许可协议或联系您的Oracle销售代表。</p>
            <p>
              有关每个版本中的更改的详细说明，请参阅
              <a class="ulink" href="http://dev.mysql.com/doc/relnotes/mysql/8.0/en/" target="_top">MySQL 8.0 Release Notes</a>.
            </p>
            <p>
              有关法律信息，包括许可信息，请参阅
              <a class="xref" href="preface.html" title="Preface and Legal Notices">Preface and Legal Notices</a>.
            </p>
            <p>
              有关使用MySQL的帮助，请访问
              <a class="ulink" href="http://forums.mysql.com" target="_top">MySQL Forums</a> or
              <a class="ulink" href="http://lists.mysql.com" target="_top">MySQL Mailing Lists</a>, 您可以在其中与其他MySQL用户讨论您的问题。
            </p>
            <p>
              生成的文档时间和版本: 2018-04-21 (revision: 57136)
            </p>
            <p>请注意：官方的https://dev.mysql.com/doc/refman/8.0/en/ 5.6 Japanese竟然有日语版本，哎，中文只有之前一个机翻校验的5.x版本的，注意官网版本revision: 57136，因为翻译时间很长版本差异会有一些</p>
            <p> 翻译：Z.X </p>
            <p> 博客： http://www.cnblogs.com/zx-admin/ </p>
            <p> QQ群： 247823727 </p>
            <p>
              <strong>注意：一些基础比如介绍，文字说明暂时不翻译，浪费时间，翻译核心部分，请注意！</strong>
            </p>
            <p>这里使用html版本翻译就是为了方便放在网页上</p>
            <p>翻译单词对照，不是专业的翻译，如果有误可对照英文原版和对照词组理解，
              <a href="words.html">点击查看</a>
            </p>

          </div>
        </div>
      </div>
      <hr>
    </div>
    <div class="toc">
      <p>
        <b>目录</b>
      </p>
      <dl class="toc">
        <dt>
          <span class="preface">
            <a href="preface.html">前言和法律声明</a>
          </span>
        </dt>
        <dt>
          <span class="chapter">
            <a href="introduction.html">1 一般信息</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="introduction.html#manual-info">1.1 关于本手册</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="introduction.html#manual-conventions">1.2 排印和语法约定</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="introduction.html#what-is">1.3 MySQL数据库管理系统概述</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="introduction.html#what-is-mysql">1.3.1 什么是MySQL?</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#features">1.3.2 MySQL的主要特性</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#history">1.3.3 MySQL的历史</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="introduction.html#mysql-nutshell">1.4 MySQL 8.0中的新功能</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="introduction.html#added-deprecated-removed">1.5 服务器和状态变量和选项在MySQL 8.0中添加，弃用或删除</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="introduction.html#information-sources">1.6 MySQL信息源</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="introduction.html#mysql-web-sites">1.6.1 MySQL网站</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#mailing-lists">1.6.2 MySQL 邮件列表</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#forums">1.6.3 MySQL MySQL论坛的社区支持</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#irc">1.6.4 MySQL互联网中继聊天（IRC）上的社区支持</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#mysql-enterprise-information">1.6.5 MySQL 企业版</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="introduction.html#bug-reports">1.7 如何报告错误或问题</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="introduction.html#compatibility">1.8 MySQL标准合规性</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="introduction.html#extensions-to-ansi">1.8.1 标准SQL的MySQL扩展</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#differences-from-ansi">1.8.2 MySQL与标准SQL的区别</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#constraints">1.8.3 MySQL如何处理约束</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="introduction.html#credits">1.9 声望和荣誉</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="introduction.html#contributors">1.9.1 MySQL的贡献者</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#documenters-translators">1.9.2 文档和翻译员</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#packages">1.9.3 支持MySQL的软件包</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#tools-used-to-create-mysql">1.9.4 用于创建MySQL的工具</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="introduction.html#supporters">1.9.5 MySQL的支持者</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="installing.html">2 安装和升级MySQL</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="installing.html#general-installation-issues">2.1 通用安装指南</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="installing.html#which-version">2.1.1 要安装的MySQL版本和分发版本</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#getting-mysql">2.1.2 如何获取MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#verifying-package-integrity">2.1.3 使用MD5校验和或GnuPG验证程序包完整性</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#installation-layouts">2.1.4 安装方案</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#compiler-characteristics">2.1.5 编译器特有的构建特性</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="installing.html#binary-installation">2.2 在Unix / Linux上使用通用二进制文件安装MySQL</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="installing.html#windows-installation">2.3 在Microsoft Windows上安装MySQL</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="installing.html#windows-installation-layout">2.3.1 Microsoft Windows上的MySQL安装方案</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#windows-choosing-package">2.3.2 选择一个安装包</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#mysql-installer">2.3.3 适用于Windows的MySQL安装程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#windows-notifier">2.3.4 MySQL通知程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#windows-install-archive">2.3.5 在Microsoft Windows上安装MySQL使用noinstall ZIP存档</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#windows-troubleshooting">2.3.6 解决Microsoft Windows MySQL服务器安装问题</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#windows-postinstallation">2.3.7 Windows安装后程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#windows-upgrading">2.3.8 在Windows上升级MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#deploy-mysql-nonlinux-docker">2.3.9 在Windows和其他非Linux平台上部署MySQL</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="installing.html#osx-installation">2.4 在macOS上安装MySQL</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="installing.html#osx-installation-notes">2.4.1 在macOS上安装MySQL的一般注意事项</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#osx-installation-pkg">2.4.2 在macOS上使用本地软件包安装MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#osx-installation-launchd">2.4.3 安装和使用MySQL启动守护程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#osx-installation-prefpane">2.4.4 安装和使用MySQL的Preference Pane( 插件名称)</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="installing.html#linux-installation">2.5 在Linux上安装MySQL</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="installing.html#linux-installation-yum-repo">2.5.1 在Linux上使用MySQL Yum源软件仓库安装MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#linux-installation-apt-repo">2.5.2 在Linux上使用MySQL APT软件仓库安装MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#linux-installation-sles-repo">2.5.3 在Linux上安装MySQL使用MySQL SLES软件仓库</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#linux-installation-rpm">2.5.4 在Linux上安装MySQL使用Oracle的RPM软件包</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#linux-installation-debian">2.5.5 在Linux上安装MySQL使用Oracle的Debian软件包</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#linux-installation-docker">2.5.6 使用Docker在Linux上部署MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#linux-installation-native">2.5.7 从本地软件仓库在Linux上安装MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#linux-installation-juju">2.5.8 用Juju在Linux上安装MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#using-systemd">2.5.9 用systemd管理MySQL服务器</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="installing.html#uln-installation">2.6 使用Unbreakable Linux网络安装MySQL（ULN）</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="installing.html#solaris-installation">2.7在Solaris上安装MySQL</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="installing.html#solaris-installation-pkg">2.7.1 在Solaris上使用Solaris PKG安装MySQL</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="installing.html#freebsd-installation">2.8 在FreeBSD上安装MySQL</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="installing.html#source-installation">2.9 从源代码安装MySQL</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="installing.html#source-installation-layout">2.9.1 源代码安装的MySQL方案</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#installing-source-distribution">2.9.2 使用标准源代码分发安装MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#installing-development-tree">2.9.3 使用开发Source Tree安装MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#source-configuration-options">2.9.4 MySQL源配置选项</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#compilation-problems">2.9.5 处理编译MySQL的问题</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#source-configuration-third-party">2.9.6 MySQL配置和第三方工具</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#source-installation-doxygen">2.9.7 生成MySQL Doxygen文档内容</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="installing.html#postinstallation">2.10 安装后设置和测试</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="installing.html#data-directory-initialization">2.10.1 初始化数据目录</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#starting-server">2.10.2 启动服务器</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#testing-server">2.10.3 测试服务器</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#default-privileges">2.10.4 确保初始MySQL帐户的安全</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#automatic-start">2.10.5 自动启动和停止MySQL</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="installing.html#upgrading-downgrading">2.11 升级或降级MySQL</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="installing.html#upgrading">2.11.1 升级MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#downgrading">2.11.2 降级MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#rebuilding-tables">2.11.3 重建或修复表或索引</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#copying-databases">2.11.4 将MySQL数据库复制到另一台机器</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="installing.html#perl-support">2.12 Perl安装说明</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="installing.html#perl-installation">2.12.1 在Unix上安装Perl</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#activestate-perl">2.12.2 在Windows上安装ActiveState Perl</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="installing.html#perl-support-problems">2.12.3 使用Perl DBI / DBD接口的问题</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="tutorial.html">3 教程</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="tutorial.html#connecting-disconnecting">3.1 连接到服务器并断开连接</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="tutorial.html#entering-queries">3.2 输入查询</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="tutorial.html#database-use">3.3 创建和使用数据库</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#creating-database">3.3.1 创建和选择数据库</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#creating-tables">3.3.2 创建一个表</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#loading-tables">3.3.3 将数据加载到表中</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#retrieving-data">3.3.4 从表中检索信息</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="tutorial.html#getting-information">3.4 获取有关数据库和表格的信息</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="tutorial.html#batch-mode">3.5 在批处理模式下使用mysql</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="tutorial.html#examples">3.6 常见查询的例子</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#example-maximum-column">3.6.1 列的最大值</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#example-maximum-row">3.6.2 该行当前某列的最大值</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#example-maximum-column-group">3.6.3 每个分组的最大列数</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#example-maximum-column-group-row">3.6.4 行当前某个列的最大集群</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#example-user-variables">3.6.5 使用用户定义的变量</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#example-foreign-keys">3.6.6 使用外键</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#searching-on-two-keys">3.6.7 搜索两个键</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#calculating-days">3.6.8 计算每天访问量</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="tutorial.html#example-auto-increment">3.6.9 使用AUTO_INCREMENT</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="tutorial.html#apache">3.7 在Apache中使用MySQL</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="programs.html">4 MySQL程序</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="programs.html#programs-overview">4.1 MySQL程序概述</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="programs.html#programs-using">4.2 使用MySQL程序</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="programs.html#invoking-programs">4.2.1 调用MySQL程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#connecting">4.2.2 连接到MySQL服务器</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#program-options">4.2.3 指定程序选项</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#command-line-options">4.2.4 使用命令行上的选项</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#option-modifiers">4.2.5 程序选项访问修饰符</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#option-files">4.2.6 使用选项文件</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#option-file-options">4.2.7 影响选项文件处理的命令行选项</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#program-variables">4.2.8 使用选项设置程序变量</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#option-defaults-equals">4.2.9 选项默认值，期望选项和=符号</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#setting-environment-variables">4.2.10 设置环境变量</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="programs.html#programs-server">4.3 MySQL服务器和服务器启动程序</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqld">4.3.1
                      <span class="command">
                        <strong>mysqld</strong>
                      </span> — MySQL服务器</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqld-safe">4.3.2
                      <span class="command">
                        <strong>mysqld_safe</strong>
                      </span> — MySQL服务器启动脚本</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysql-server">4.3.3
                      <span class="command">
                        <strong>mysql.server</strong>
                      </span> — MySQL服务器启动脚本</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqld-multi">4.3.4
                      <span class="command">
                        <strong>mysqld_multi</strong>
                      </span> — 管理多个MySQL服务器</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="programs.html#programs-installation">4.4 MySQL安装相关程序</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="programs.html#comp-err">4.4.1
                      <span class="command">
                        <strong>comp_err</strong>
                      </span> — 编译MySQL错误消息文件</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysql-secure-installation">4.4.2
                      <span class="command">
                        <strong>mysql_secure_installation</strong>
                      </span> — 提高MySQL安装安全性</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysql-ssl-rsa-setup">4.4.3
                      <span class="command">
                        <strong>mysql_ssl_rsa_setup</strong>
                      </span> — 创建SSL / RSA文件</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysql-tzinfo-to-sql">4.4.4
                      <span class="command">
                        <strong>mysql_tzinfo_to_sql</strong>
                      </span> — 加载时区表</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysql-upgrade">4.4.5
                      <span class="command">
                        <strong>mysql_upgrade</strong>
                      </span> — 检查并升级MySQL表</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="programs.html#programs-client">4.5 MySQL客户端程序</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysql">4.5.1
                      <span class="command">
                        <strong>mysql</strong>
                      </span> — MySQL命令行工具</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqladmin">4.5.2
                      <span class="command">
                        <strong>mysqladmin</strong>
                      </span> — 用于管理MySQL服务器的客户端</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqlcheck">4.5.3
                      <span class="command">
                        <strong>mysqlcheck</strong>
                      </span> — 表维护计划程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqldump">4.5.4
                      <span class="command">
                        <strong>mysqldump</strong>
                      </span> — 数据库备份程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqlimport">4.5.5
                      <span class="command">
                        <strong>mysqlimport</strong>
                      </span> — 数据导入程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqlpump">4.5.6
                      <span class="command">
                        <strong>mysqlpump</strong>
                      </span> — 数据库备份程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqlsh">4.5.7
                      <span class="command">
                        <strong>mysqlsh</strong>
                      </span> — MySQL Shell</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqlshow">4.5.8
                      <span class="command">
                        <strong>mysqlshow</strong>
                      </span> — 显示数据库，表格和列信息</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqlslap">4.5.9
                      <span class="command">
                        <strong>mysqlslap</strong>
                      </span> — 加载仿真客户端</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="programs.html#programs-admin-utils">4.6 MySQL管理和应用程序</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="programs.html#ibd2sdi">4.6.1
                      <span class="command">
                        <strong>ibd2sdi</strong>
                      </span> — InnoDB Tablespace SDI抽取应用程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#innochecksum">4.6.2
                      <span class="command">
                        <strong>innochecksum</strong>
                      </span> — 离线InnoDB文件校验和应用程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#myisam-ftdump">4.6.3
                      <span class="command">
                        <strong>myisam_ftdump</strong>
                      </span> — 显示全文索引信息</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#myisamchk">4.6.4
                      <span class="command">
                        <strong>myisamchk</strong>
                      </span> — MyISAM表维护实用程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#myisamlog">4.6.5
                      <span class="command">
                        <strong>myisamlog</strong>
                      </span> — 显示MyISAM日志文件内容</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#myisampack">4.6.6
                      <span class="command">
                        <strong>myisampack</strong>
                      </span> — 生成压缩的只读MyISAM表</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysql-config-editor">4.6.7
                      <span class="command">
                        <strong>mysql_config_editor</strong>
                      </span> — MySQL配置应用程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqlbinlog">4.6.8
                      <span class="command">
                        <strong>mysqlbinlog</strong>
                      </span> — 处理二进制日志文件的应用程序</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysqldumpslow">4.6.9
                      <span class="command">
                        <strong>mysqldumpslow</strong>
                      </span> — 总结慢速查询日志文件</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="programs.html#programs-development">4.7 MySQL程序开发应用程序</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="programs.html#mysql-config">4.7.1
                      <span class="command">
                        <strong>mysql_config</strong>
                      </span> — 用于编译客户端的显示选项</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#my-print-defaults">4.7.2
                      <span class="command">
                        <strong>my_print_defaults</strong>
                      </span> — 显示来自选项文件的选项</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#resolve-stack-dump">4.7.3
                      <span class="command">
                        <strong>resolve_stack_dump</strong>
                      </span> — 将数值堆栈跟踪转储解析为符号</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="programs.html#programs-miscellaneous">4.8 杂项程序</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="programs.html#lz4-decompress">4.8.1
                      <span class="command">
                        <strong>lz4_decompress</strong>
                      </span> — 解压缩mysqlpump LZ4-压缩输出</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#perror">4.8.2
                      <span class="command">
                        <strong>perror</strong>
                      </span> — 解释错误代码</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#resolveip">4.8.3
                      <span class="command">
                        <strong>resolveip</strong>
                      </span> — 将主机名解析为IP地址或副本
                    </a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="programs.html#zlib-decompress">4.8.4
                      <span class="command">
                        <strong>zlib_decompress</strong>
                      </span> — 解压缩mysqlpump ZLIB压缩输出</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="programs.html#environment-variables">4.9 MySQL程序环境变量</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="server-administration.html">5 MySQL服务器管理</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="server-administration.html#mysqld-server">5.1 MySQL服务器</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#server-configuration">5.1.1 配置服务器</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#server-configuration-defaults">5.1.2 服务器配置默认值</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#mysqld-option-tables">5.1.3 服务器选项和参考变量</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#server-options">5.1.4 服务器命令选项</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#server-system-variables">5.1.5 服务器系统变量</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#using-system-variables">5.1.6 使用系统变量</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#server-status-variables">5.1.7 服务器状态变量</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#sql-mode">5.1.8 服务器SQL模式</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#ipv6-support">5.1.9 IPv6支持</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#time-zone-support">5.1.10 MySQL服务器时区支持</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#server-side-help-support">5.1.11 服务器端帮助</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#server-signal-response">5.1.12 服务器对信号的响应</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#server-shutdown">5.1.13 服务器关机过程</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="server-administration.html#data-directory">5.2 MySQL数据目录</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="server-administration.html#system-database">5.3 mysql系统数据库</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="server-administration.html#server-logs">5.4 MySQL服务器日志</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#log-destinations">5.4.1 选择常规查询和慢速查询日志输出目标</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#error-log">5.4.2 The Error Log</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#query-log">5.4.3 The General Query Log</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#binary-log">5.4.4 The Binary Log</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#slow-query-log">5.4.5 The Slow Query Log</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#ddl-log">5.4.6 The DDL Log</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#log-file-maintenance">5.4.7 Server Log Maintenance</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="server-administration.html#server-components">5.5 MySQL Server Components</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#error-log-components">5.5.1 Error Log Components</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="server-administration.html#server-plugins">5.6 MySQL Server Plugins</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#server-plugin-loading">5.6.1 Installing and Uninstalling Plugins</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#obtaining-plugin-information">5.6.2 Obtaining Server Plugin Information</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#thread-pool">5.6.3 MySQL Enterprise Thread Pool</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#rewriter-query-rewrite-plugin">5.6.4 The Rewriter Query Rewrite Plugin</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#version-tokens">5.6.5 Version Tokens</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="server-administration.html#multiple-servers">5.7 Running Multiple MySQL Instances on One Machine</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#multiple-data-directories">5.7.1 Setting Up Multiple Data Directories</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#multiple-windows-servers">5.7.2 Running Multiple MySQL Instances on Windows</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#multiple-unix-servers">5.7.3 Running Multiple MySQL Instances on Unix</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="server-administration.html#multiple-server-clients">5.7.4 Using Client Programs in a Multiple-Server Environment</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="security.html">6 Security</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="security.html#general-security-issues">6.1 General Security Issues</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="security.html#security-guidelines">6.1.1 Security Guidelines</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#password-security">6.1.2 Keeping Passwords Secure</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#security-against-attack">6.1.3 Making MySQL Secure Against Attackers</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#security-options">6.1.4 Security-Related mysqld Options and Variables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#changing-mysql-user">6.1.5 How to Run MySQL as a Normal User</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#load-data-local">6.1.6 Security Issues with LOAD DATA LOCAL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#secure-client-programming">6.1.7 Client Programming Security Guidelines</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="security.html#privilege-system">6.2 The MySQL Access Privilege System</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="security.html#privileges-provided">6.2.1 Privileges Provided by MySQL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#static-dynamic-privileges">6.2.2 Static Versus Dynamic Privileges</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#grant-tables">6.2.3 Grant Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#account-names">6.2.4 Specifying Account Names</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#role-names">6.2.5 Specifying Role Names</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#connection-access">6.2.6 Access Control, Stage 1: Connection Verification</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#request-access">6.2.7 Access Control, Stage 2: Request Verification</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#privilege-changes">6.2.8 When Privilege Changes Take Effect</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#problems-connecting">6.2.9 Troubleshooting Problems Connecting to MySQL</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="security.html#user-account-management">6.3 MySQL User Account Management</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="security.html#user-names">6.3.1 User Names and Passwords</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#adding-users">6.3.2 Adding User Accounts</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#removing-users">6.3.3 Removing User Accounts</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#roles">6.3.4 Using Roles</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#reserved-users">6.3.5 Reserved User Accounts</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#user-resources">6.3.6 Setting Account Resource Limits</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#assigning-passwords">6.3.7 Assigning Account Passwords</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#password-management">6.3.8 Password Management</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#expired-password-handling">6.3.9 Server Handling of Expired Passwords</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#pluggable-authentication">6.3.10 Pluggable Authentication</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#proxy-users">6.3.11 Proxy Users</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#account-locking">6.3.12 User Account Locking</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#account-activity-auditing">6.3.13 SQL-Based MySQL Account Activity Auditing</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="security.html#encrypted-connections">6.4 Using Encrypted Connections</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="security.html#using-encrypted-connections">6.4.1 Configuring MySQL to Use Encrypted Connections</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#encrypted-connection-options">6.4.2 Command Options for Encrypted Connections</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#creating-ssl-rsa-files">6.4.3 Creating SSL and RSA Certificates and Keys</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#ssl-libraries">6.4.4 OpenSSL Versus wolfSSL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#building-with-encrypted-connection-support">6.4.5 Building MySQL with Support for Encrypted Connections</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#encrypted-connection-protocols-ciphers">6.4.6 Encrypted Connection Protocols and Ciphers</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#windows-and-ssh">6.4.7 Connecting to MySQL Remotely from Windows with SSH</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="security.html#security-plugins">6.5 Security Components and Plugins</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="security.html#authentication-plugins">6.5.1 Authentication Plugins</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#connection-control">6.5.2 The Connection-Control Plugins</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#validate-password">6.5.3 The Password Validation Component</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#keyring">6.5.4 The MySQL Keyring</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#audit-log">6.5.5 MySQL Enterprise Audit</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="security.html#firewall">6.5.6 MySQL Enterprise Firewall</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="security.html#fips-mode">6.6 FIPS Support</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="backup-and-recovery.html">7 Backup and Recovery</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="backup-and-recovery.html#backup-types">7.1 Backup and Recovery Types</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="backup-and-recovery.html#backup-methods">7.2 Database Backup Methods</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="backup-and-recovery.html#backup-strategy-example">7.3 Example Backup and Recovery Strategy</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#backup-policy">7.3.1 Establishing a Backup Policy</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#recovery-from-backups">7.3.2 Using Backups for Recovery</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#backup-strategy-summary">7.3.3 Backup Strategy Summary</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="backup-and-recovery.html#using-mysqldump">7.4 Using mysqldump for Backups</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#mysqldump-sql-format">7.4.1 Dumping Data in SQL Format with mysqldump</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#reloading-sql-format-dumps">7.4.2 Reloading SQL-Format Backups</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#mysqldump-delimited-text">7.4.3 Dumping Data in Delimited-Text Format with mysqldump</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#reloading-delimited-text-dumps">7.4.4 Reloading Delimited-Text Format Backups</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#mysqldump-tips">7.4.5 mysqldump Tips</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="backup-and-recovery.html#point-in-time-recovery">7.5 Point-in-Time (Incremental) Recovery Using the Binary Log</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#point-in-time-recovery-times">7.5.1 Point-in-Time Recovery Using Event Times</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#point-in-time-recovery-positions">7.5.2 Point-in-Time Recovery Using Event Positions</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="backup-and-recovery.html#myisam-table-maintenance">7.6 MyISAM Table Maintenance and Crash Recovery</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#myisam-crash-recovery">7.6.1 Using myisamchk for Crash Recovery</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#myisam-check">7.6.2 How to Check MyISAM Tables for Errors</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#myisam-repair">7.6.3 How to Repair MyISAM Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#myisam-optimization">7.6.4 MyISAM Table Optimization</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="backup-and-recovery.html#myisam-maintenance-schedule">7.6.5 Setting Up a MyISAM Table Maintenance Schedule</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="optimization.html">8 Optimization</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="optimization.html#optimize-overview">8.1 Optimization Overview</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="optimization.html#statement-optimization">8.2 Optimizing SQL Statements</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#select-optimization">8.2.1 Optimizing SELECT Statements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#subquery-optimization">8.2.2 Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions
                    </a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#information-schema-optimization">8.2.3 Optimizing INFORMATION_SCHEMA Queries</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#performance-schema-optimization">8.2.4 Optimizing Performance Schema Queries</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#data-change-optimization">8.2.5 Optimizing Data Change Statements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#permission-optimization">8.2.6 Optimizing Database Privileges</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#miscellaneous-optimization-tips">8.2.7 Other Optimization Tips</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="optimization.html#optimization-indexes">8.3 Optimization and Indexes</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#mysql-indexes">8.3.1 How MySQL Uses Indexes</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#primary-key-optimization">8.3.2 Primary Key Optimization</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#spatial-index-optimization">8.3.3 SPATIAL Index Optimization</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#foreign-key-optimization">8.3.4 Foreign Key Optimization</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#column-indexes">8.3.5 Column Indexes</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#multiple-column-indexes">8.3.6 Multiple-Column Indexes</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#verifying-index-usage">8.3.7 Verifying Index Usage</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#index-statistics">8.3.8 InnoDB and MyISAM Index Statistics Collection</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#index-btree-hash">8.3.9 Comparison of B-Tree and Hash Indexes</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#index-extensions">8.3.10 Use of Index Extensions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#generated-column-index-optimizations">8.3.11 Optimizer Use of Generated Column Indexes</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#invisible-indexes">8.3.12 Invisible Indexes</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#descending-indexes">8.3.13 Descending Indexes</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="optimization.html#optimizing-database-structure">8.4 Optimizing Database Structure</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#data-size">8.4.1 Optimizing Data Size</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimize-data-types">8.4.2 Optimizing MySQL Data Types</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimize-multi-tables">8.4.3 Optimizing for Many Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#internal-temporary-tables">8.4.4 Internal Temporary Table Use in MySQL</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="optimization.html#optimizing-innodb">8.5 Optimizing for InnoDB Tables</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-innodb-storage-layout">8.5.1 Optimizing Storage Layout for InnoDB Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-innodb-transaction-management">8.5.2 Optimizing InnoDB Transaction Management</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#innodb-performance-ro-txn">8.5.3 Optimizing InnoDB Read-Only Transactions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-innodb-logging">8.5.4 Optimizing InnoDB Redo Logging</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-innodb-bulk-data-loading">8.5.5 Bulk Data Loading for InnoDB Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-innodb-queries">8.5.6 Optimizing InnoDB Queries</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-innodb-ddl-operations">8.5.7 Optimizing InnoDB DDL Operations</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-innodb-diskio">8.5.8 Optimizing InnoDB Disk I/O</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-innodb-configuration-variables">8.5.9 Optimizing InnoDB Configuration Variables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-innodb-many-tables">8.5.10 Optimizing InnoDB for Systems with Many Tables</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="optimization.html#optimizing-myisam">8.6 Optimizing for MyISAM Tables</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-queries-myisam">8.6.1 Optimizing MyISAM Queries</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-myisam-bulk-data-loading">8.6.2 Bulk Data Loading for MyISAM Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#repair-table-optimization">8.6.3 Optimizing REPAIR TABLE Statements</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="optimization.html#optimizing-memory-tables">8.7 Optimizing for MEMORY Tables</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="optimization.html#execution-plan-information">8.8 Understanding the Query Execution Plan</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#using-explain">8.8.1 Optimizing Queries with EXPLAIN</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#explain-output">8.8.2 EXPLAIN Output Format</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#explain-extended">8.8.3 Extended EXPLAIN Output Format</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#explain-for-connection">8.8.4 Obtaining Execution Plan Information for a Named Connection</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#estimating-performance">8.8.5 Estimating Query Performance</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="optimization.html#controlling-optimizer">8.9 Controlling the Query Optimizer</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#controlling-query-plan-evaluation">8.9.1 Controlling Query Plan Evaluation</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizer-hints">8.9.2 Optimizer Hints</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#switchable-optimizations">8.9.3 Switchable Optimizations</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#index-hints">8.9.4 Index Hints</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#cost-model">8.9.5 The Optimizer Cost Model</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizer-statistics">8.9.6 Optimizer Statistics</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="optimization.html#buffering-caching">8.10 Buffering and Caching</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#innodb-buffer-pool-optimization">8.10.1 InnoDB Buffer Pool Optimization</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#myisam-key-cache">8.10.2 The MyISAM Key Cache</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#statement-caching">8.10.3 Caching of Prepared Statements and Stored Programs</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="optimization.html#locking-issues">8.11 Optimizing Locking Operations</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#internal-locking">8.11.1 Internal Locking Methods</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#table-locking">8.11.2 Table Locking Issues</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#concurrent-inserts">8.11.3 Concurrent Inserts</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#metadata-locking">8.11.4 Metadata Locking</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#external-locking">8.11.5 External Locking</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="optimization.html#optimizing-server">8.12 Optimizing the MySQL Server</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#disk-issues">8.12.1 Optimizing Disk I/O</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#symbolic-links">8.12.2 Using Symbolic Links</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-memory">8.12.3 Optimizing Memory Use</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#optimizing-network">8.12.4 Optimizing Network Use</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#resource-groups">8.12.5 Resource Groups</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="optimization.html#optimize-benchmarking">8.13 Measuring Performance (Benchmarking)</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#select-benchmarking">8.13.1 Measuring the Speed of Expressions and Functions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#custom-benchmarks">8.13.2 Using Your Own Benchmarks</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#monitoring-performance-schema">8.13.3 Measuring Performance with performance_schema</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="optimization.html#thread-information">8.14 Examining Thread Information</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="optimization.html#thread-commands">8.14.1 Thread Command Values</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#general-thread-states">8.14.2 General Thread States</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#master-thread-states">8.14.3 Replication Master Thread States</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#slave-io-thread-states">8.14.4 Replication Slave I/O Thread States</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#slave-sql-thread-states">8.14.5 Replication Slave SQL Thread States</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#slave-connection-thread-states">8.14.6 Replication Slave Connection Thread States</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="optimization.html#event-scheduler-thread-states">8.14.7 Event Scheduler Thread States</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="language-structure.html">9 Language Structure</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="language-structure.html#literals">9.1 Literal Values</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="language-structure.html#string-literals">9.1.1 String Literals</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="language-structure.html#number-literals">9.1.2 Numeric Literals</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="language-structure.html#date-and-time-literals">9.1.3 Date and Time Literals</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="language-structure.html#hexadecimal-literals">9.1.4 Hexadecimal Literals</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="language-structure.html#bit-value-literals">9.1.5 Bit-Value Literals</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="language-structure.html#boolean-literals">9.1.6 Boolean Literals</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="language-structure.html#null-values">9.1.7 NULL Values</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="language-structure.html#identifiers">9.2 Schema Object Names</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="language-structure.html#identifier-qualifiers">9.2.1 Identifier Qualifiers</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="language-structure.html#identifier-case-sensitivity">9.2.2 Identifier Case Sensitivity</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="language-structure.html#identifier-mapping">9.2.3 Mapping of Identifiers to File Names</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="language-structure.html#function-resolution">9.2.4 Function Name Parsing and Resolution</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="language-structure.html#keywords">9.3 Keywords and Reserved Words</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="language-structure.html#user-variables">9.4 User-Defined Variables</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="language-structure.html#expressions">9.5 Expression Syntax</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="language-structure.html#comments">9.6 Comment Syntax</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="charset.html">10 Character Sets, Collations, Unicode</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="charset.html#charset-general">10.1 Character Sets and Collations in General</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="charset.html#charset-mysql">10.2 Character Sets and Collations in MySQL</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-repertoire">10.2.1 Character Set Repertoire</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-metadata">10.2.2 UTF-8 for Metadata</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="charset.html#charset-syntax">10.3 Specifying Character Sets and Collations</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-collation-names">10.3.1 Collation Naming Conventions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-server">10.3.2 Server Character Set and Collation</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-database">10.3.3 Database Character Set and Collation</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-table">10.3.4 Table Character Set and Collation</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-column">10.3.5 Column Character Set and Collation</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-literal">10.3.6 Character String Literal Character Set and Collation</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-national">10.3.7 The National Character Set</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-introducer">10.3.8 Character Set Introducers</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-examples">10.3.9 Examples of Character Set and Collation Assignment</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-compatibility">10.3.10 Compatibility with Other DBMSs</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="charset.html#charset-connection">10.4 Connection Character Sets and Collations</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="charset.html#charset-applications">10.5 Configuring Application Character Set and Collation</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="charset.html#charset-errors">10.6 Error Message Character Set</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="charset.html#charset-conversion">10.7 Column Character Set Conversion</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="charset.html#charset-collations">10.8 Collation Issues</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-collate">10.8.1 Using COLLATE in SQL Statements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-collate-precedence">10.8.2 COLLATE Clause Precedence</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-collation-compatibility">10.8.3 Character Set and Collation Compatibility</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-collation-coercibility">10.8.4 Collation Coercibility in Expressions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-binary-collations">10.8.5 The binary Collation Compared to _bin Collations</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-collation-effect">10.8.6 Examples of the Effect of Collation</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-collation-information-schema">10.8.7 Using Collation in INFORMATION_SCHEMA Searches</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="charset.html#charset-unicode">10.9 Unicode Support</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-unicode-utf8mb4">10.9.1 The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-unicode-utf8mb3">10.9.2 The utf8mb3 Character Set (3-Byte UTF-8 Unicode Encoding)</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-unicode-utf8">10.9.3 The utf8 Character Set (Alias for utf8mb3)</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-unicode-ucs2">10.9.4 The ucs2 Character Set (UCS-2 Unicode Encoding)</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-unicode-utf16">10.9.5 The utf16 Character Set (UTF-16 Unicode Encoding)</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-unicode-utf16le">10.9.6 The utf16le Character Set (UTF-16LE Unicode Encoding)</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-unicode-utf32">10.9.7 The utf32 Character Set (UTF-32 Unicode Encoding)</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-unicode-conversion">10.9.8 Converting Between 3-Byte and 4-Byte Unicode Character Sets</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="charset.html#charset-charsets">10.10 Supported Character Sets and Collations</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-unicode-sets">10.10.1 Unicode Character Sets</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-we-sets">10.10.2 West European Character Sets</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-ce-sets">10.10.3 Central European Character Sets</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-se-me-sets">10.10.4 South European and Middle East Character Sets</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-baltic-sets">10.10.5 Baltic Character Sets</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-cyrillic-sets">10.10.6 Cyrillic Character Sets</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-asian-sets">10.10.7 Asian Character Sets</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-binary-set">10.10.8 The Binary Character Set</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="charset.html#error-message-language">10.11 Setting the Error Message Language</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="charset.html#adding-character-set">10.12 Adding a Character Set</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="charset.html#character-arrays">10.12.1 Character Definition Arrays</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#string-collating">10.12.2 String Collating Support for Complex Character Sets</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#multibyte-characters">10.12.3 Multi-Byte Character Support for Complex Character Sets</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="charset.html#adding-collation">10.13 Adding a Collation to a Character Set</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="charset.html#charset-collation-implementations">10.13.1 Collation Implementation Types</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#adding-collation-choosing-id">10.13.2 Choosing a Collation ID</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#adding-collation-simple-8bit">10.13.3 Adding a Simple Collation to an 8-Bit Character Set</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="charset.html#adding-collation-unicode-uca">10.13.4 Adding a UCA Collation to a Unicode Character Set</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="charset.html#charset-configuration">10.14 Character Set Configuration</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="charset.html#locale-support">10.15 MySQL Server Locale Support</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="data-types.html">11 Data Types</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="data-types.html#data-type-overview">11.1 Data Type Overview</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="data-types.html#numeric-type-overview">11.1.1 Numeric Type Overview</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#date-and-time-type-overview">11.1.2 Date and Time Type Overview</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#string-type-overview">11.1.3 String Type Overview</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="data-types.html#numeric-types">11.2 Numeric Types</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="data-types.html#integer-types">11.2.1 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#fixed-point-types">11.2.2 Fixed-Point Types (Exact Value) - DECIMAL, NUMERIC</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#floating-point-types">11.2.3 Floating-Point Types (Approximate Value) - FLOAT, DOUBLE</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#bit-type">11.2.4 Bit-Value Type - BIT</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#numeric-type-attributes">11.2.5 Numeric Type Attributes</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#out-of-range-and-overflow">11.2.6 Out-of-Range and Overflow Handling</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="data-types.html#date-and-time-types">11.3 Date and Time Types</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="data-types.html#datetime">11.3.1 The DATE, DATETIME, and TIMESTAMP Types</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#time">11.3.2 The TIME Type</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#year">11.3.3 The YEAR Type</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#migrating-to-year4">11.3.4 Migrating YEAR(2) Columns to YEAR(4)</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#timestamp-initialization">11.3.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#fractional-seconds">11.3.6 Fractional Seconds in Time Values</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#date-and-time-type-conversion">11.3.7 Conversion Between Date and Time Types</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#two-digit-years">11.3.8 Two-Digit Years in Dates</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="data-types.html#string-types">11.4 String Types</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="data-types.html#char">11.4.1 The CHAR and VARCHAR Types</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#binary-varbinary">11.4.2 The BINARY and VARBINARY Types</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#blob">11.4.3 The BLOB and TEXT Types</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#enum">11.4.4 The ENUM Type</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#set">11.4.5 The SET Type</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="data-types.html#spatial-types">11.5 Spatial Data Types</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="data-types.html#spatial-type-overview">11.5.1 Spatial Data Types</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#opengis-geometry-model">11.5.2 The OpenGIS Geometry Model</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#gis-data-formats">11.5.3 Supported Spatial Data Formats</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#geometry-well-formedness-validity">11.5.4 Geometry Well-Formedness and Validity</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#spatial-reference-systems">11.5.5 Spatial Reference System Support</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#creating-spatial-columns">11.5.6 Creating Spatial Columns</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#populating-spatial-columns">11.5.7 Populating Spatial Columns</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#fetching-spatial-data">11.5.8 Fetching Spatial Data</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#optimizing-spatial-analysis">11.5.9 Optimizing Spatial Analysis</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#creating-spatial-indexes">11.5.10 Creating Spatial Indexes</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="data-types.html#using-spatial-indexes">11.5.11 Using Spatial Indexes</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="data-types.html#json">11.6 The JSON Data Type</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="data-types.html#data-type-defaults">11.7 Data Type Default Values</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="data-types.html#storage-requirements">11.8 Data Type Storage Requirements</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="data-types.html#choosing-types">11.9 Choosing the Right Type for a Column</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="data-types.html#other-vendor-data-types">11.10 Using Data Types from Other Database Engines</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="functions.html">12 Functions and Operators</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="functions.html#func-op-summary-ref">12.1 Function and Operator Reference</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#type-conversion">12.2 Type Conversion in Expression Evaluation</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#non-typed-operators">12.3 Operators</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="functions.html#operator-precedence">12.3.1 Operator Precedence</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#comparison-operators">12.3.2 Comparison Functions and Operators</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#logical-operators">12.3.3 Logical Operators</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#assignment-operators">12.3.4 Assignment Operators</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="functions.html#control-flow-functions">12.4 Control Flow Functions</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#string-functions">12.5 String Functions</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="functions.html#string-comparison-functions">12.5.1 String Comparison Functions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#regexp">12.5.2 Regular Expressions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#string-functions-charset">12.5.3 Character Set and Collation of Function Results</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="functions.html#numeric-functions">12.6 Numeric Functions and Operators</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="functions.html#arithmetic-functions">12.6.1 Arithmetic Operators</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#mathematical-functions">12.6.2 Mathematical Functions</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="functions.html#date-and-time-functions">12.7 Date and Time Functions</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#mysql-calendar">12.8 What Calendar Is Used By MySQL?</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#fulltext-search">12.9 Full-Text Search Functions</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="functions.html#fulltext-natural-language">12.9.1 Natural Language Full-Text Searches</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#fulltext-boolean">12.9.2 Boolean Full-Text Searches</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#fulltext-query-expansion">12.9.3 Full-Text Searches with Query Expansion</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#fulltext-stopwords">12.9.4 Full-Text Stopwords</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#fulltext-restrictions">12.9.5 Full-Text Restrictions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#fulltext-fine-tuning">12.9.6 Fine-Tuning MySQL Full-Text Search</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#full-text-adding-collation">12.9.7 Adding a Collation for Full-Text Indexing</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#fulltext-search-ngram">12.9.8 ngram Full-Text Parser</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#fulltext-search-mecab">12.9.9 MeCab Full-Text Parser Plugin</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="functions.html#cast-functions">12.10 Cast Functions and Operators</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#xml-functions">12.11 XML Functions</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#bit-functions">12.12 Bit Functions and Operators</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#encryption-functions">12.13 Encryption and Compression Functions</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#information-functions">12.14 Information Functions</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#spatial-analysis-functions">12.15 Spatial Analysis Functions</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="functions.html#spatial-function-reference">12.15.1 Spatial Function Reference</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#spatial-function-argument-handling">12.15.2 Argument Handling by Spatial Functions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#gis-wkt-functions">12.15.3 Functions That Create Geometry Values from WKT Values</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#gis-wkb-functions">12.15.4 Functions That Create Geometry Values from WKB Values</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#gis-mysql-specific-functions">12.15.5 MySQL-Specific Functions That Create Geometry Values</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#gis-format-conversion-functions">12.15.6 Geometry Format Conversion Functions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#gis-property-functions">12.15.7 Geometry Property Functions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#spatial-operator-functions">12.15.8 Spatial Operator Functions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#spatial-relation-functions">12.15.9 Functions That Test Spatial Relations Between Geometry Objects</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#spatial-geohash-functions">12.15.10 Spatial Geohash Functions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#spatial-geojson-functions">12.15.11 Spatial GeoJSON Functions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#spatial-convenience-functions">12.15.12 Spatial Convenience Functions</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="functions.html#json-functions">12.16 JSON Functions</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="functions.html#json-function-reference">12.16.1 JSON Function Reference</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#json-creation-functions">12.16.2 Functions That Create JSON Values</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#json-search-functions">12.16.3 Functions That Search JSON Values</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#json-modification-functions">12.16.4 Functions That Modify JSON Values</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#json-attribute-functions">12.16.5 Functions That Return JSON Value Attributes</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#json-table-functions">12.16.6 JSON Table Functions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#json-utility-functions">12.16.7 JSON Utility Functions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#json-path-syntax">12.16.8 JSON Path Syntax</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="functions.html#gtid-functions">12.17 Functions Used with Global Transaction IDs</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#enterprise-encryption">12.18 MySQL Enterprise Encryption Functions</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="functions.html#enterprise-encryption-installation">12.18.1 Enterprise Encryption Installation</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#enterprise-encryption-usage">12.18.2 Enterprise Encryption Usage and Examples</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#enterprise-encryption-function-reference">12.18.3 Enterprise Encryption Function Reference</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#enterprise-encryption-functions">12.18.4 Enterprise Encryption Function Descriptions</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="functions.html#group-by-functions-and-modifiers">12.19 Aggregate (GROUP BY) Functions</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="functions.html#group-by-functions">12.19.1 Aggregate (GROUP BY) Function Descriptions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#group-by-modifiers">12.19.2 GROUP BY Modifiers</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#group-by-handling">12.19.3 MySQL Handling of GROUP BY</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#group-by-functional-dependence">12.19.4 Detection of Functional Dependence</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="functions.html#window-functions">12.20 Window Functions</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="functions.html#window-function-descriptions">12.20.1 Window Function Descriptions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#window-functions-usage">12.20.2 Window Function Concepts and Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#window-functions-frames">12.20.3 Window Function Frame Specification</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#window-functions-named-windows">12.20.4 Named Windows</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#window-function-restrictions">12.20.5 Window Function Restrictions</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="functions.html#internal-functions">12.21 Internal Functions</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#miscellaneous-functions">12.22 Miscellaneous Functions</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="functions.html#precision-math">12.23 Precision Math</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="functions.html#precision-math-numbers">12.23.1 Types of Numeric Values</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#precision-math-decimal-characteristics">12.23.2 DECIMAL Data Type Characteristics</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#precision-math-expressions">12.23.3 Expression Handling</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#precision-math-rounding">12.23.4 Rounding Behavior</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="functions.html#precision-math-examples">12.23.5 Precision Math Examples</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="sql-syntax.html">13 SQL Statement Syntax</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="sql-syntax.html#sql-syntax-data-definition">13.1 Data Definition Statements</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#atomic-ddl">13.1.1 Atomic Data Definition Statement Support</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#alter-database">13.1.2 ALTER DATABASE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#alter-event">13.1.3 ALTER EVENT Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#alter-function">13.1.4 ALTER FUNCTION Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#alter-instance">13.1.5 ALTER INSTANCE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#alter-procedure">13.1.6 ALTER PROCEDURE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#alter-server">13.1.7 ALTER SERVER Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#alter-table">13.1.8 ALTER TABLE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#alter-tablespace">13.1.9 ALTER TABLESPACE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#alter-view">13.1.10 ALTER VIEW Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#create-database">13.1.11 CREATE DATABASE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#create-event">13.1.12 CREATE EVENT Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#create-function">13.1.13 CREATE FUNCTION Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#create-index">13.1.14 CREATE INDEX Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#create-procedure">13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#create-server">13.1.16 CREATE SERVER Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#create-spatial-reference-system">13.1.17 CREATE SPATIAL REFERENCE SYSTEM Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#create-table">13.1.18 CREATE TABLE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#create-tablespace">13.1.19 CREATE TABLESPACE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#create-trigger">13.1.20 CREATE TRIGGER Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#create-view">13.1.21 CREATE VIEW Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#drop-database">13.1.22 DROP DATABASE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#drop-event">13.1.23 DROP EVENT Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#drop-function">13.1.24 DROP FUNCTION Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#drop-index">13.1.25 DROP INDEX Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#drop-procedure">13.1.26 DROP PROCEDURE and DROP FUNCTION Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#drop-server">13.1.27 DROP SERVER Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#drop-spatial-reference-system">13.1.28 DROP SPATIAL REFERENCE SYSTEM Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#drop-table">13.1.29 DROP TABLE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#drop-tablespace">13.1.30 DROP TABLESPACE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#drop-trigger">13.1.31 DROP TRIGGER Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#drop-view">13.1.32 DROP VIEW Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#rename-table">13.1.33 RENAME TABLE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#truncate-table">13.1.34 TRUNCATE TABLE Syntax</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="sql-syntax.html#sql-syntax-data-manipulation">13.2 Data Manipulation Statements</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#call">13.2.1 CALL Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#delete">13.2.2 DELETE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#do">13.2.3 DO Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#handler">13.2.4 HANDLER Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#import-table">13.2.5 IMPORT TABLE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#insert">13.2.6 INSERT Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#load-data">13.2.7 LOAD DATA INFILE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#load-xml">13.2.8 LOAD XML Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#replace">13.2.9 REPLACE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#select">13.2.10 SELECT Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#subqueries">13.2.11 Subquery Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#update">13.2.12 UPDATE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#with">13.2.13 WITH Syntax (Common Table Expressions)</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="sql-syntax.html#sql-syntax-transactions">13.3 Transactional and Locking Statements</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#commit">13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#cannot-roll-back">13.3.2 Statements That Cannot Be Rolled Back</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#implicit-commit">13.3.3 Statements That Cause an Implicit Commit</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#savepoint">13.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#lock-instance-for-backup">13.3.5 LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#lock-tables">13.3.6 LOCK TABLES and UNLOCK TABLES Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#set-transaction">13.3.7 SET TRANSACTION Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#xa">13.3.8 XA Transactions</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="sql-syntax.html#sql-syntax-replication">13.4 Replication Statements</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#replication-master-sql">13.4.1 SQL Statements for Controlling Master Servers</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#replication-slave-sql">13.4.2 SQL Statements for Controlling Slave Servers</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#replication-group-sql">13.4.3 SQL Statements for Controlling Group Replication</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="sql-syntax.html#sql-syntax-prepared-statements">13.5 Prepared SQL Statement Syntax</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#prepare">13.5.1 PREPARE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#execute">13.5.2 EXECUTE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#deallocate-prepare">13.5.3 DEALLOCATE PREPARE Syntax</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="sql-syntax.html#sql-syntax-compound-statements">13.6 Compound-Statement Syntax</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#begin-end">13.6.1 BEGIN ... END Compound-Statement Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#statement-labels">13.6.2 Statement Label Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#declare">13.6.3 DECLARE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#stored-program-variables">13.6.4 Variables in Stored Programs</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#flow-control-statements">13.6.5 Flow Control Statements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#cursors">13.6.6 Cursors</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#condition-handling">13.6.7 Condition Handling</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="sql-syntax.html#sql-syntax-server-administration">13.7 Database Administration Statements</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#account-management-sql">13.7.1 Account Management Statements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#resource-group-sql">13.7.2 Resource Group Management Statements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#table-maintenance-sql">13.7.3 Table Maintenance Statements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#component-sql">13.7.4 Component, Plugin, and User-Defined Function Statements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#set-statement">13.7.5 SET Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#show">13.7.6 SHOW Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#other-administrative-sql">13.7.7 Other Administrative Statements</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="sql-syntax.html#sql-syntax-utility">13.8 Utility Statements</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#describe">13.8.1 DESCRIBE Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#explain">13.8.2 EXPLAIN Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#help">13.8.3 HELP Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sql-syntax.html#use">13.8.4 USE Syntax</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="data-dictionary.html">14 MySQL Data Dictionary</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="data-dictionary.html#data-dictionary-schema">14.1 Data Dictionary Schema</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="data-dictionary.html#data-dictionary-file-removal">14.2 Removal of File-based Metadata Storage</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="data-dictionary.html#data-dictionary-transactional-storage">14.3 Transactional Storage of Dictionary Data</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="data-dictionary.html#data-dictionary-object-cache">14.4 Dictionary Object Cache</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="data-dictionary.html#data-dictionary-information-schema">14.5 INFORMATION_SCHEMA and Data Dictionary Integration</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="data-dictionary.html#serialized-dictionary-information">14.6 Serialized Dictionary Information (SDI)</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="data-dictionary.html#data-dictionary-usage-differences">14.7 Data Dictionary Usage Differences</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="data-dictionary.html#data-dictionary-limitations">14.8 Data Dictionary Limitations</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="innodb-storage-engine.html">15 The InnoDB Storage Engine</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-introduction">15.1 Introduction to InnoDB</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-benefits">15.1.1 Benefits of Using InnoDB Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-best-practices">15.1.2 Best Practices for InnoDB Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-check-availability">15.1.3 Verifying that InnoDB is the Default Storage Engine</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-benchmarking">15.1.4 Testing and Benchmarking with InnoDB</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#mysql-acid">15.2 InnoDB and the ACID Model</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-multi-versioning">15.3 InnoDB Multi-Versioning</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-concepts">15.4 InnoDB Architecture</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-buffer-pool-intro">15.4.1 Buffer Pool</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-insert-buffering">15.4.2 Change Buffer</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-adaptive-hash">15.4.3 Adaptive Hash Index</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-redo-log-buffer">15.4.4 Redo Log Buffer</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-system-tablespace">15.4.5 System Tablespace</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-doublewrite-buffer">15.4.6 Doublewrite Buffer</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-undo-logs">15.4.7 Undo Logs</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-file-per-table-intro">15.4.8 File-Per-Table Tablespaces</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-general-tablespace-intro">15.4.9 General Tablespaces</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-undo-tablespace-intro">15.4.10 Undo Tablespace</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-temporary-tablespace">15.4.11 Temporary Tablespace</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-redo-log">15.4.12 Redo Log</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-locking-transaction-model">15.5 InnoDB Locking and Transaction Model</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-locking">15.5.1 InnoDB Locking</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-transaction-model">15.5.2 InnoDB Transaction Model</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-locks-set">15.5.3 Locks Set by Different SQL Statements in InnoDB</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-next-key-locking">15.5.4 Phantom Rows</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-deadlocks">15.5.5 Deadlocks in InnoDB</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-configuration">15.6 InnoDB Configuration</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-init-startup-configuration">15.6.1 InnoDB Startup Configuration</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-read-only-instance">15.6.2 Configuring InnoDB for Read-Only Operation</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-performance-buffer-pool">15.6.3 InnoDB Buffer Pool Configuration</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-performance-change_buffering">15.6.4 Configuring InnoDB Change Buffering</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-performance-thread_concurrency">15.6.5 Configuring Thread Concurrency for InnoDB</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-performance-multiple_io_threads">15.6.6 Configuring the Number of Background InnoDB I/O Threads</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-linux-native-aio">15.6.7 Using Asynchronous I/O on Linux</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-performance-thread_io_rate">15.6.8 Configuring the InnoDB Master Thread I/O Rate</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-performance-spin_lock_polling">15.6.9 Configuring Spin Lock Polling</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-improved-purge-scheduling">15.6.10 Configuring InnoDB Purge Scheduling</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-performance-optimizer-statistics">15.6.11 Configuring Optimizer Statistics for InnoDB</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#index-page-merge-threshold">15.6.12 Configuring the Merge Threshold for Index Pages</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-dedicated-server">15.6.13 Enabling Automatic Configuration for a Dedicated MySQL Server</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-tablespace">15.7 InnoDB Tablespaces</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-resize-system-tablespace">15.7.1 Resizing the InnoDB System Tablespace</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-data-log-reconfiguration">15.7.2 Changing the Number or Size of InnoDB Redo Log Files</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-raw-devices">15.7.3 Using Raw Disk Partitions for the System Tablespace</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-multiple-tablespaces">15.7.4 InnoDB File-Per-Table Tablespaces</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#tablespace-placing">15.7.5 Creating File-Per-Table Tablespaces Outside the Data Directory</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#tablespace-copying">15.7.6 Copying File-Per-Table Tablespaces to Another Instance</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-moving-data-files-offline">15.7.7 Moving Tablespace Files While the Server is Offline</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-undo-tablespace">15.7.8 Configuring Undo Tablespaces</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#truncate-undo-tablespace">15.7.9 Truncating Undo Tablespaces</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#general-tablespaces">15.7.10 InnoDB General Tablespaces</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-tablespace-encryption">15.7.11 InnoDB Tablespace Encryption</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-tables-indexes">15.8 InnoDB Tables and Indexes</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-tables">15.8.1 InnoDB Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-indexes">15.8.2 InnoDB Indexes</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-compression">15.9 InnoDB Table and Page Compression</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-table-compression">15.9.1 InnoDB Table Compression</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-page-compression">15.9.2 InnoDB Page Compression</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-row-format">15.10 InnoDB Row Storage and Row Formats</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-row-format-overview">15.10.1 Overview of InnoDB Row Storage</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-row-format-specification">15.10.2 Specifying the Row Format for a Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-row-format-dynamic">15.10.3 DYNAMIC and COMPRESSED Row Formats</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-row-format-antelope">15.10.4 COMPACT and REDUNDANT Row Formats</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-disk-management">15.11 InnoDB Disk I/O and File Space Management</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-disk-io">15.11.1 InnoDB Disk I/O</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-file-space">15.11.2 File Space Management</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-checkpoints">15.11.3 InnoDB Checkpoints</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-file-defragmenting">15.11.4 Defragmenting a Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-truncate-table-reclaim-space">15.11.5 Reclaiming Disk Space with TRUNCATE TABLE</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-online-ddl">15.12 InnoDB and Online DDL</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-create-index-overview">15.12.1 Online DDL Overview</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-create-index-concurrency">15.12.2 Online DDL Performance, Concurrency, and Space Requirements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-online-ddl-syntax">15.12.3 Online DDL SQL Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-online-ddl-single-multi">15.12.4 Simplifying DDL Statements with Online DDL</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-create-index-implementation">15.12.5 Online DDL Implementation Details</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#online-ddl-partitioning">15.12.6 Online DDL for Partitioned Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-create-index-limitations">15.12.7 Online DDL Limitations</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-parameters">15.13 InnoDB Startup Options and System Variables</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-information-schema">15.14 InnoDB INFORMATION_SCHEMA Tables</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-information-schema-compression-tables">15.14.1 InnoDB INFORMATION_SCHEMA Tables about Compression</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-information-schema-transactions">15.14.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-information-schema-system-tables">15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-information-schema-fulltext_index-tables">15.14.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-information-schema-buffer-pool-tables">15.14.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-information-schema-metrics-table">15.14.6 InnoDB INFORMATION_SCHEMA Metrics Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-information-schema-temp-table-info">15.14.7 InnoDB INFORMATION_SCHEMA Temporary Table Info Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-information-schema-files-table">15.14.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-performance-schema">15.15 InnoDB Integration with MySQL Performance Schema</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#monitor-alter-table-performance-schema">15.15.1 Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema
                    </a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#monitor-innodb-mutex-waits-performance-schema">15.15.2 Monitoring InnoDB Mutex Waits Using Performance Schema</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-monitors">15.16 InnoDB Monitors</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-monitor-types">15.16.1 InnoDB Monitor Types</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-enabling-monitors">15.16.2 Enabling InnoDB Monitors</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-standard-monitor">15.16.3 InnoDB Standard Monitor and Lock Monitor Output</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-backup-recovery">15.17 InnoDB Backup and Recovery</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-backup">15.17.1 InnoDB Backup</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-recovery">15.17.2 InnoDB Recovery</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-and-mysql-replication">15.18 InnoDB and MySQL Replication</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-memcached">15.19 InnoDB memcached Plugin</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-memcached-benefits">15.19.1 Benefits of the InnoDB memcached Plugin</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-memcached-intro">15.19.2 InnoDB memcached Architecture</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-memcached-setup">15.19.3 Setting Up the InnoDB memcached Plugin</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-memcached-multiple-get-range-query">15.19.4 InnoDB memcached Multiple get and Range Query Support</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-memcached-security">15.19.5 Security Considerations for the InnoDB memcached Plugin</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-memcached-developing">15.19.6 Writing Applications for the InnoDB memcached Plugin</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-memcached-replication">15.19.7 The InnoDB memcached Plugin and Replication</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-memcached-internals">15.19.8 InnoDB memcached Plugin Internals</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-memcached-troubleshoot">15.19.9 Troubleshooting the InnoDB memcached Plugin</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="innodb-storage-engine.html#innodb-troubleshooting">15.20 InnoDB Troubleshooting</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#error-creating-innodb">15.20.1 Troubleshooting InnoDB I/O Problems</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#forcing-innodb-recovery">15.20.2 Forcing InnoDB Recovery</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-troubleshooting-datadict">15.20.3 Troubleshooting InnoDB Data Dictionary Operations</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="innodb-storage-engine.html#innodb-error-handling">15.20.4 InnoDB Error Handling</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="storage-engines.html">16 Alternative Storage Engines</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="storage-engines.html#storage-engine-setting">16.1 Setting the Storage Engine</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="storage-engines.html#myisam-storage-engine">16.2 The MyISAM Storage Engine</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#myisam-start">16.2.1 MyISAM Startup Options</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#key-space">16.2.2 Space Needed for Keys</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#myisam-table-formats">16.2.3 MyISAM Table Storage Formats</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#myisam-table-problems">16.2.4 MyISAM Table Problems</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="storage-engines.html#memory-storage-engine">16.3 The MEMORY Storage Engine</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="storage-engines.html#csv-storage-engine">16.4 The CSV Storage Engine</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#se-csv-repair">16.4.1 Repairing and Checking CSV Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#se-csv-limitations">16.4.2 CSV Limitations</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="storage-engines.html#archive-storage-engine">16.5 The ARCHIVE Storage Engine</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="storage-engines.html#blackhole-storage-engine">16.6 The BLACKHOLE Storage Engine</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="storage-engines.html#merge-storage-engine">16.7 The MERGE Storage Engine</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#merge-table-advantages">16.7.1 MERGE Table Advantages and Disadvantages</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#merge-table-problems">16.7.2 MERGE Table Problems</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="storage-engines.html#federated-storage-engine">16.8 The FEDERATED Storage Engine</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#federated-description">16.8.1 FEDERATED Storage Engine Overview</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#federated-create">16.8.2 How to Create FEDERATED Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#federated-usagenotes">16.8.3 FEDERATED Storage Engine Notes and Tips</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#federated-storage-engine-resources">16.8.4 FEDERATED Storage Engine Resources</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="storage-engines.html#example-storage-engine">16.9 The EXAMPLE Storage Engine</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="storage-engines.html#storage-engines-other">16.10 Other Storage Engines</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="storage-engines.html#pluggable-storage-overview">16.11 Overview of MySQL Storage Engine Architecture</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#pluggable-storage">16.11.1 Pluggable Storage Engine Architecture</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="storage-engines.html#pluggable-storage-common-layer">16.11.2 The Common Database Server Layer</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="replication.html">17 Replication</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="replication.html#replication-configuration">17.1 Configuring Replication</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="replication.html#binlog-replication-configuration-overview">17.1.1 Binary Log File Position Based Replication Configuration Overview</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-howto">17.1.2 Setting Up Binary Log File Position Based Replication</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-gtids">17.1.3 Replication with Global Transaction Identifiers</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-multi-source">17.1.4 MySQL Multi-Source Replication</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-mode-change-online">17.1.5 Changing Replication Modes on Online Servers</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-options">17.1.6 Replication and Binary Logging Options and Variables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-administration">17.1.7 Common Replication Administration Tasks</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="replication.html#replication-implementation">17.2 Replication Implementation</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-formats">17.2.1 Replication Formats</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-implementation-details">17.2.2 Replication Implementation Details</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-channels">17.2.3 Replication Channels</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#slave-logs">17.2.4 Replication Relay and Status Logs</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-rules">17.2.5 How Servers Evaluate Replication Filtering Rules</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="replication.html#replication-solutions">17.3 Replication Solutions</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-solutions-backups">17.3.1 Using Replication for Backups</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-solutions-unexpected-slave-halt">17.3.2 Handling an Unexpected Halt of a Replication Slave</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-solutions-rbr-monitoring">17.3.3 Monitoring Row-based Replication</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-solutions-diffengines">17.3.4 Using Replication with Different Master and Slave Storage Engines</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-solutions-scaleout">17.3.5 Using Replication for Scale-Out</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-solutions-partitioning">17.3.6 Replicating Different Databases to Different Slaves</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-solutions-performance">17.3.7 Improving Replication Performance</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-solutions-switch">17.3.8 Switching Masters During Failover</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-solutions-encrypted-connections">17.3.9 Setting Up Replication to Use Encrypted Connections</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-semisync">17.3.10 Semisynchronous Replication</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-delayed">17.3.11 Delayed Replication</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="replication.html#replication-notes">17.4 Replication Notes and Tips</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-features">17.4.1 Replication Features and Issues</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-compatibility">17.4.2 Replication Compatibility Between MySQL Versions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-upgrade">17.4.3 Upgrading a Replication Setup</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-problems">17.4.4 Troubleshooting Replication</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="replication.html#replication-bugs">17.4.5 How to Report Replication Bugs or Problems</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="group-replication.html">18 Group Replication</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="group-replication.html#group-replication-background">18.1 Group Replication Background</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-replication-technologies">18.1.1 Replication Technologies</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-use-cases">18.1.2 Group Replication Use Cases</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-details">18.1.3 Group Replication Details</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="group-replication.html#group-replication-getting-started">18.2 Getting Started</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-deploying-in-single-primary-mode">18.2.1 Deploying Group Replication in Single-Primary Mode</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="group-replication.html#group-replication-monitoring">18.3 Monitoring Group Replication</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-replication-group-member-stats">18.3.1 Replication_group_member_stats</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-replication-group-members">18.3.2 Replication_group_members</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-replication-connection-status">18.3.3 Replication_connection_status</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-replication-applier-status">18.3.4 Replication_applier_status</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-server-states">18.3.5 Group Replication Server States</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="group-replication.html#group-replication-operations">18.4 Group Replication Operations</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-deploying-in-multi-primary-or-single-primary-mode">18.4.1 Deploying in Multi-Primary or Single-Primary Mode</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-tuning-recovery">18.4.2 Tuning Recovery</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-network-partitioning">18.4.3 Network Partitioning</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-enterprise-backup">18.4.4 Using MySQL Enterprise Backup with Group Replication</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="group-replication.html#group-replication-security">18.5 Group Replication Security</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-ip-address-whitelisting">18.5.1 IP Address Whitelisting</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-secure-socket-layer-support-ssl">18.5.2 Secure Socket Layer Support (SSL)</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-virtual-private-networks-vpn">18.5.3 Virtual Private Networks (VPN)</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="group-replication.html#group-replication-options">18.6 Group Replication System Variables</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="group-replication.html#group-replication-requirements-and-limitations">18.7 Requirements and Limitations</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-requirements">18.7.1 Group Replication Requirements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-limitations">18.7.2 Group Replication Limitations</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="group-replication.html#group-replication-frequently-asked-questions">18.8 Frequently Asked Questions</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="group-replication.html#group-replication-technical-details">18.9 Group Replication Technical Details</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-plugin-architecture">18.9.1 Group Replication Plugin Architecture</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-the-group">18.9.2 The Group</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-data-manipulation-statements">18.9.3 Data Manipulation Statements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-data-definition-statements">18.9.4 Data Definition Statements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-distributed-recovery">18.9.5 Distributed Recovery</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-observability">18.9.6 Observability</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="group-replication.html#group-replication-performance">18.9.7 Group Replication Performance</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="mysql-shell.html">19 MySQL Shell User Guide</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="mysql-shell.html#mysql-shell-features">19.1 MySQL Shell Features</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="mysql-shell.html#mysql-shell-getting-started">19.2 Getting Started with MySQL Shell</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-connections">19.2.1 MySQL Shell Connections</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-sessions">19.2.2 MySQL Shell Sessions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-global-variables">19.2.3 MySQL Shell Global Variables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-working-with-history">19.2.4 MySQL Shell Code History</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="mysql-shell.html#mysql-shell-code-execution">19.3 MySQL Shell Code Execution</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-interactive-code-execution">19.3.1 Interactive Code Execution</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-autocompletion">19.3.2 Code Autocompletion</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-batch-code-execution">19.3.3 Batch Code Execution</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-output-formats">19.3.4 Output Formats</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-active-language">19.3.5 Active Language</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-batch-mode-interactive">19.3.6 Batch Mode Made Interactive</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="mysql-shell.html#mysql-shell-configuring">19.4 Configuring MySQL Shell</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-commands">19.4.1 MySQL Shell Commands</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="mysql-shell.html#mysql-shell-utilities">19.5 MySQL Shell Utilities</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="mysql-shell.html#mysql-shell-application-log">19.6 MySQL Shell Application Log</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-application-log-introduction">19.6.1 Application Log</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="mysql-shell.html#mysql-shell-customizing">19.7 Customizing MySQL Shell</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-creating-startup-scripts">19.7.1 Working With Start-Up Scripts</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-adding-module-search-paths">19.7.2 Adding Module Search Paths</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-prompt-themes">19.7.3 Customizing the Prompt</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-shell.html#mysql-shell-configuring-options">19.7.4 Configuring MySQL Shell</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="document-store.html">20 Using MySQL as a Document Store</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="document-store.html#document-store-concepts">20.1 Key Concepts</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="document-store.html#document-store-setting-up">20.2 Setting Up MySQL as a Document Store</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="document-store.html#document-store-shell-install">20.2.1 Installing MySQL Shell</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#installing-mysql-shell-starting">20.2.2 Starting MySQL Shell</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="document-store.html#mysql-shell-tutorial-javascript">20.3 Quick-Start Guide: MySQL Shell for JavaScript</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-javascript-introduction">20.3.1 Introduction</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-javascript-download">20.3.2 Import Database Sample</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-javascript-shell">20.3.3 MySQL Shell</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-javascript-documents-collections">20.3.4 Documents and Collections</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-javascript-relational-tables">20.3.5 Relational Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-javascript-documents-in-tables">20.3.6 Documents in Tables</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="document-store.html#mysql-shell-tutorial-python">20.4 Quick-Start Guide: MySQL Shell for Python</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-python-introduction">20.4.1 Introduction</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-python-download">20.4.2 Import Database Sample</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-python-shell">20.4.3 MySQL Shell</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-python-collections">20.4.4 Documents and Collections</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-python-relational-tables">20.4.5 Relational Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#mysql-shell-tutorial-python-documents-in-tables">20.4.6 Documents in Tables</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="document-store.html#mysql-shell-visual-studio">20.5 Quick-Start Guide: MySQL for Visual Studio</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="document-store.html#x-plugin">20.6 X Plugin</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="document-store.html#x-plugin-ssl-connections">20.6.1 Using Secure Connections with X Plugin</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#x-plugin-sha2-cache-plugin">20.6.2 Using X Plugin with the Caching SHA-2 Authentication Plugin</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#x-plugin-options-variables">20.6.3 X Plugin Options and Variables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="document-store.html#x-plugin-system-monitoring">20.6.4 Monitoring X Plugin</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="mysql-innodb-cluster-userguide.html">21 InnoDB Cluster</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="mysql-innodb-cluster-userguide.html#mysql-innodb-cluster-introduction">21.1 Introducing InnoDB Cluster</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="mysql-innodb-cluster-userguide.html#mysql-innodb-cluster-creating">21.2 Creating an InnoDB Cluster</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="mysql-innodb-cluster-userguide.html#mysql-innodb-cluster-deployment-methods">21.2.1 Deployment Scenarios</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-innodb-cluster-userguide.html#mysql-innodb-cluster-requirements">21.2.2 InnoDB Cluster Requirements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-innodb-cluster-userguide.html#mysql-innodb-cluster-methods-installing">21.2.3 Methods of Installing</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-innodb-cluster-userguide.html#mysql-innodb-cluster-production-deployment">21.2.4 Production Deployment of InnoDB Cluster</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-innodb-cluster-userguide.html#mysql-innodb-cluster-sandbox-deployment">21.2.5 Sandbox Deployment of InnoDB Cluster</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="mysql-innodb-cluster-userguide.html#mysql-innodb-cluster-from-group-replication">21.2.6 Adopting a Group Replication Deployment</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="mysql-innodb-cluster-userguide.html#mysql-innodb-cluster-using-router">21.3 Using MySQL Router with InnoDB Cluster</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="mysql-innodb-cluster-userguide.html#mysql-innodb-cluster-working-with-cluster">21.4 Working with InnoDB Cluster</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="mysql-innodb-cluster-userguide.html#mysql-innodb-cluster-limitations">21.5 Known Limitations</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="partitioning.html">22 Partitioning</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="partitioning.html#partitioning-overview">22.1 Overview of Partitioning in MySQL</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="partitioning.html#partitioning-types">22.2 Partitioning Types</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-range">22.2.1 RANGE Partitioning</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-list">22.2.2 LIST Partitioning</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-columns">22.2.3 COLUMNS Partitioning</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-hash">22.2.4 HASH Partitioning</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-key">22.2.5 KEY Partitioning</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-subpartitions">22.2.6 Subpartitioning</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-handling-nulls">22.2.7 How MySQL Partitioning Handles NULL</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="partitioning.html#partitioning-management">22.3 Partition Management</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-management-range-list">22.3.1 Management of RANGE and LIST Partitions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-management-hash-key">22.3.2 Management of HASH and KEY Partitions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-management-exchange">22.3.3 Exchanging Partitions and Subpartitions with Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-maintenance">22.3.4 Maintenance of Partitions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-info">22.3.5 Obtaining Information About Partitions</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="partitioning.html#partitioning-pruning">22.4 Partition Pruning</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="partitioning.html#partitioning-selection">22.5 Partition Selection</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="partitioning.html#partitioning-limitations">22.6 Restrictions and Limitations on Partitioning</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-limitations-partitioning-keys-unique-keys">22.6.1 Partitioning Keys, Primary Keys, and Unique Keys</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-limitations-storage-engines">22.6.2 Partitioning Limitations Relating to Storage Engines</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="partitioning.html#partitioning-limitations-functions">22.6.3 Partitioning Limitations Relating to Functions</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="stored-programs-views.html">23 Stored Programs and Views</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="stored-programs-views.html#stored-programs-defining">23.1 Defining Stored Programs</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="stored-programs-views.html#stored-routines">23.2 Using Stored Routines (Procedures and Functions)</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#stored-routines-syntax">23.2.1 Stored Routine Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#stored-routines-privileges">23.2.2 Stored Routines and MySQL Privileges</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#stored-routines-metadata">23.2.3 Stored Routine Metadata</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#stored-routines-last-insert-id">23.2.4 Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="stored-programs-views.html#triggers">23.3 Using Triggers</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#trigger-syntax">23.3.1 Trigger Syntax and Examples</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#trigger-metadata">23.3.2 Trigger Metadata</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="stored-programs-views.html#event-scheduler">23.4 Using the Event Scheduler</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#events-overview">23.4.1 Event Scheduler Overview</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#events-configuration">23.4.2 Event Scheduler Configuration</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#events-syntax">23.4.3 Event Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#events-metadata">23.4.4 Event Metadata</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#events-status-info">23.4.5 Event Scheduler Status</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#events-privileges">23.4.6 The Event Scheduler and MySQL Privileges</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="stored-programs-views.html#views">23.5 Using Views</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#view-syntax">23.5.1 View Syntax</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#view-algorithms">23.5.2 View Processing Algorithms</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#view-updatability">23.5.3 Updatable and Insertable Views</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#view-check-option">23.5.4 The View WITH CHECK OPTION Clause</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="stored-programs-views.html#view-metadata">23.5.5 View Metadata</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="stored-programs-views.html#stored-programs-security">23.6 Access Control for Stored Programs and Views</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="stored-programs-views.html#stored-programs-logging">23.7 Binary Logging of Stored Programs</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="information-schema.html">24 INFORMATION_SCHEMA Tables</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="information-schema.html#character-sets-table">24.1 The INFORMATION_SCHEMA CHARACTER_SETS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#collations-table">24.2 The INFORMATION_SCHEMA COLLATIONS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#collation-character-set-applicability-table">24.3 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#columns-table">24.4 The INFORMATION_SCHEMA COLUMNS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#column-privileges-table">24.5 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#column-statistics-table">24.6 The INFORMATION_SCHEMA COLUMN_STATISTICS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#engines-table">24.7 The INFORMATION_SCHEMA ENGINES Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#events-table">24.8 The INFORMATION_SCHEMA EVENTS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#files-table">24.9 The INFORMATION_SCHEMA FILES Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#key-column-usage-table">24.10 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#keywords-table">24.11 The INFORMATION_SCHEMA KEYWORDS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#optimizer-trace-table">24.12 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#parameters-table">24.13 The INFORMATION_SCHEMA PARAMETERS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#partitions-table">24.14 The INFORMATION_SCHEMA PARTITIONS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#plugins-table">24.15 The INFORMATION_SCHEMA PLUGINS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#processlist-table">24.16 The INFORMATION_SCHEMA PROCESSLIST Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#profiling-table">24.17 The INFORMATION_SCHEMA PROFILING Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#referential-constraints-table">24.18 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#resource-groups-table">24.19 The INFORMATION_SCHEMA RESOURCE_GROUPS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#routines-table">24.20 The INFORMATION_SCHEMA ROUTINES Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#schemata-table">24.21 The INFORMATION_SCHEMA SCHEMATA Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#schema-privileges-table">24.22 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#statistics-table">24.23 The INFORMATION_SCHEMA STATISTICS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#st-geometry-columns-table">24.24 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#st-spatial-reference-systems-table">24.25 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#tables-table">24.26 The INFORMATION_SCHEMA TABLES Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#tablespaces-table">24.27 The INFORMATION_SCHEMA TABLESPACES Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#table-constraints-table">24.28 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#table-privileges-table">24.29 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#triggers-table">24.30 The INFORMATION_SCHEMA TRIGGERS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#user-privileges-table">24.31 The INFORMATION_SCHEMA USER_PRIVILEGES Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#views-table">24.32 The INFORMATION_SCHEMA VIEWS Table</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="information-schema.html#innodb-i_s-tables">24.33 InnoDB INFORMATION_SCHEMA Tables</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-buffer-page-table">24.33.1 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-buffer-page-lru-table">24.33.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-buffer-pool-stats-table">24.33.3 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-cached-indexes-table">24.33.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-cmp-table">24.33.5 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-cmpmem-table">24.33.6 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-cmp-per-index-table">24.33.7 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-ft-being-deleted-table">24.33.8 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-ft-config-table">24.33.9 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-ft-default-stopword-table">24.33.10 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-ft-deleted-table">24.33.11 The INFORMATION_SCHEMA INNODB_FT_DELETED Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-ft-index-cache-table">24.33.12 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-ft-index-table-table">24.33.13 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-locks-table">24.33.14 The INFORMATION_SCHEMA INNODB_LOCKS Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-lock-waits-table">24.33.15 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-metrics-table">24.33.16 The INFORMATION_SCHEMA INNODB_METRICS Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-columns-table">24.33.17 The INFORMATION_SCHEMA INNODB_COLUMNS Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-datafiles-table">24.33.18 The INFORMATION_SCHEMA INNODB_DATAFILES Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-fields-table">24.33.19 The INFORMATION_SCHEMA INNODB_FIELDS Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-foreign-table">24.33.20 The INFORMATION_SCHEMA INNODB_FOREIGN Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-foreign-cols-table">24.33.21 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-indexes-table">24.33.22 The INFORMATION_SCHEMA INNODB_INDEXES Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-tables-table">24.33.23 The INFORMATION_SCHEMA INNODB_TABLES Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-tablespaces-table">24.33.24 The INFORMATION_SCHEMA INNODB_TABLESPACES Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-tablespaces-brief-table">24.33.25 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-tablestats-table">24.33.26 The INFORMATION_SCHEMA INNODB_TABLESTATS View</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-virtual-table">24.33.27 The INFORMATION_SCHEMA INNODB_VIRTUAL Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-temp-table-info-table">24.33.28 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#innodb-trx-table">24.33.29 The INFORMATION_SCHEMA INNODB_TRX Table</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="information-schema.html#thread-pool-i_s-tables">24.34 Thread Pool INFORMATION_SCHEMA Tables</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#tp-thread-group-state-table">24.34.1 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#tp-thread-group-stats-table">24.34.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#tp-thread-state-table">24.34.3 The INFORMATION_SCHEMA TP_THREAD_STATE Table</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="information-schema.html#connection-control-i_s-tables">24.35 Connection-Control INFORMATION_SCHEMA Tables</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="information-schema.html#connection-control-failed-login-attempts-table">24.35.1 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="information-schema.html#extended-show">24.36 Extensions to SHOW Statements</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="performance-schema.html">25 MySQL Performance Schema</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-quick-start">25.1 Performance Schema Quick Start</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-build-configuration">25.2 Performance Schema Build Configuration</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-startup-configuration">25.3 Performance Schema Startup Configuration</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-runtime-configuration">25.4 Performance Schema Runtime Configuration</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-timing">25.4.1 Performance Schema Event Timing</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-filtering">25.4.2 Performance Schema Event Filtering</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-pre-filtering">25.4.3 Event Pre-Filtering</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-instrument-filtering">25.4.4 Pre-Filtering by Instrument</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-object-filtering">25.4.5 Pre-Filtering by Object</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-thread-filtering">25.4.6 Pre-Filtering by Thread</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-consumer-filtering">25.4.7 Pre-Filtering by Consumer</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-consumer-configurations">25.4.8 Example Consumer Configurations</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-filtering-names">25.4.9 Naming Instruments or Consumers for Filtering Operations</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-instrumentation-checking">25.4.10 Determining What Is Instrumented</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-queries">25.5 Performance Schema Queries</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-instrument-naming">25.6 Performance Schema Instrument Naming Conventions</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-status-monitoring">25.7 Performance Schema Status Monitoring</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-atom-molecule-events">25.8 Performance Schema Atom and Molecule Events</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-statement-digests">25.9 Performance Schema Statement Digests and Sampling</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-table-characteristics">25.10 Performance Schema General Table Characteristics</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-table-descriptions">25.11 Performance Schema Table Descriptions</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-table-index">25.11.1 Performance Schema Table Index</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-setup-tables">25.11.2 Performance Schema Setup Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-instance-tables">25.11.3 Performance Schema Instance Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-wait-tables">25.11.4 Performance Schema Wait Event Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-stage-tables">25.11.5 Performance Schema Stage Event Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-statement-tables">25.11.6 Performance Schema Statement Event Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-transaction-tables">25.11.7 Performance Schema Transaction Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-connection-tables">25.11.8 Performance Schema Connection Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-connection-attribute-tables">25.11.9 Performance Schema Connection Attribute Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-user-variable-tables">25.11.10 Performance Schema User Variable Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-replication-tables">25.11.11 Performance Schema Replication Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-lock-tables">25.11.12 Performance Schema Lock Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-system-variable-tables">25.11.13 Performance Schema System Variable Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-status-variable-tables">25.11.14 Performance Schema Status Variable Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-summary-tables">25.11.15 Performance Schema Summary Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-miscellaneous-tables">25.11.16 Performance Schema Miscellaneous Tables</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-option-variable-reference">25.12 Performance Schema Option and Variable Reference</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-options">25.13 Performance Schema Command Options</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-system-variables">25.14 Performance Schema System Variables</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-status-variables">25.15 Performance Schema Status Variables</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-memory-model">25.16 The Performance Schema Memory-Allocation Model</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-and-plugins">25.17 Performance Schema and Plugins</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="performance-schema.html#performance-schema-examples">25.18 Using the Performance Schema to Diagnose Problems</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="performance-schema.html#performance-schema-query-profiling">25.18.1 Query Profiling Using Performance Schema</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="sys-schema.html">26 MySQL sys Schema</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="sys-schema.html#sys-schema-prerequisites">26.1 Prerequisites for Using the sys Schema</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="sys-schema.html#sys-schema-usage">26.2 Using the sys Schema</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="sys-schema.html#sys-schema-progress-reporting">26.3 sys Schema Progress Reporting</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="sys-schema.html#sys-schema-reference">26.4 sys Schema Object Reference</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="sys-schema.html#sys-schema-object-index">26.4.1 sys Schema Object Index</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sys-schema.html#sys-schema-tables">26.4.2 sys Schema Tables and Triggers</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sys-schema.html#sys-schema-views">26.4.3 sys Schema Views</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sys-schema.html#sys-schema-procedures">26.4.4 sys Schema Stored Procedures</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="sys-schema.html#sys-schema-functions">26.4.5 sys Schema Stored Functions</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="connectors-apis.html">27 Connectors and APIs</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#connector-c-info">27.1 MySQL Connector/C</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#connector-cpp-info">27.2 MySQL Connector/C++</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#connector-j-info">27.3 MySQL Connector/J</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#connector-net-info">27.4 MySQL Connector/Net</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#connector-odbc-info">27.5 MySQL Connector/ODBC</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#connector-python-info">27.6 MySQL Connector/Python</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#c-api">27.7 MySQL C API</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-implementations">27.7.1 MySQL C API Implementations</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-multiple-installations">27.7.2 Simultaneous MySQL Server and Connector/C Installations</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-example-programs">27.7.3 Example C API Client Programs</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-building-running-clients">27.7.4 Building and Running C API Client Programs</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-data-structures">27.7.5 C API Data Structures</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-function-overview">27.7.6 C API Function Overview</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-functions">27.7.7 C API Function Descriptions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-prepared-statements">27.7.8 C API Prepared Statements</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-prepared-statement-data-structures">27.7.9 C API Prepared Statement Data Structures</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-prepared-statement-function-overview">27.7.10 C API Prepared Statement Function Overview</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-prepared-statement-functions">27.7.11 C API Prepared Statement Function Descriptions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-thread-functions">27.7.12 C API Threaded Function Descriptions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-plugin-functions">27.7.13 C API Client Plugin Functions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-binary-log-interface">27.7.14 C API Binary Log Interface</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-binary-log-data-structures">27.7.15 C API Binary Log Data Structures</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-binary-log-function-overview">27.7.16 C API Binary Log Function Overview</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-binary-log-functions">27.7.17 C API Binary Log Function Descriptions</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-encrypted-connections">27.7.18 C API Encrypted Connection Support</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-multiple-queries">27.7.19 C API Multiple Statement Execution Support</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-prepared-statement-date-handling">27.7.20 C API Prepared Statement Handling of Date and Time Values</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-prepared-call-statements">27.7.21 C API Prepared CALL Statement Support</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-prepared-statement-problems">27.7.22 C API Prepared Statement Problems</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-optional-metadata">27.7.23 C API Optional Result Set Metadata</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-auto-reconnect">27.7.24 C API Automatic Reconnection Control</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#c-api-common-issues">27.7.25 C API Common Issues</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#apis-php-info">27.8 MySQL PHP API</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#apis-perl">27.9 MySQL Perl API</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#apis-python">27.10 MySQL Python API</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#apis-ruby">27.11 MySQL Ruby APIs</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#apis-ruby-mysqlruby">27.11.1 The MySQL/Ruby API</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="connectors-apis.html#apis-ruby-rubymysql">27.11.2 The Ruby/MySQL API</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#apis-tcl">27.12 MySQL Tcl API</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="connectors-apis.html#apis-eiffel">27.13 MySQL Eiffel Wrapper</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="extending-mysql.html">28 Extending MySQL</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="extending-mysql.html#mysql-internals">28.1 MySQL Internals</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#mysql-threads">28.1.1 MySQL Threads</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#mysql-test-suite">28.1.2 The MySQL Test Suite</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="extending-mysql.html#plugin-api">28.2 The MySQL Plugin API</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#plugin-types">28.2.1 Types of Plugins</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#plugin-api-characteristics">28.2.2 Plugin API Characteristics</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#plugin-api-components">28.2.3 Plugin API Components</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#writing-plugins">28.2.4 Writing Plugins</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="extending-mysql.html#component-plugin-services">28.3 MySQL Services for Components and Plugins</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#locking-service">28.3.1 The Locking Service</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#keyring-service">28.3.2 The Keyring Service</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="extending-mysql.html#adding-functions">28.4 Adding New Functions to MySQL</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#udf-features">28.4.1 Features of the User-Defined Function Interface</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#adding-udf">28.4.2 Adding a New User-Defined Function</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#adding-native-function">28.4.3 Adding a New Native Function</a>
                  </span>
                </dt>
              </dl>
            </dd>
            <dt>
              <span class="section">
                <a href="extending-mysql.html#porting">28.5 Debugging and Porting MySQL</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#debugging-server">28.5.1 Debugging a MySQL Server</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#debugging-client">28.5.2 Debugging a MySQL Client</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="extending-mysql.html#dbug-package">28.5.3 The DBUG Package</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="mysql-enterprise.html">29 MySQL Enterprise Edition</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="mysql-enterprise.html#mysql-enterprise-monitor">29.1 MySQL Enterprise Monitor Overview</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="mysql-enterprise.html#mysql-enterprise-backup">29.2 MySQL Enterprise Backup Overview</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="mysql-enterprise.html#mysql-enterprise-security">29.3 MySQL Enterprise Security Overview</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="mysql-enterprise.html#mysql-enterprise-encryption">29.4 MySQL Enterprise Encryption Overview</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="mysql-enterprise.html#mysql-enterprise-audit">29.5 MySQL Enterprise Audit Overview</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="mysql-enterprise.html#mysql-enterprise-firewall">29.6 MySQL Enterprise Firewall Overview</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="mysql-enterprise.html#mysql-enterprise-thread-pool">29.7 MySQL Enterprise Thread Pool Overview</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="chapter">
            <a href="workbench.html">30 MySQL Workbench</a>
          </span>
        </dt>
        <dt>
          <span class="appendix">
            <a href="faqs.html">A MySQL 8.0 Frequently Asked Questions</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-general">A.1 MySQL 8.0 FAQ: General</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-storage-engines">A.2 MySQL 8.0 FAQ: Storage Engines</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-sql-modes">A.3 MySQL 8.0 FAQ: Server SQL Mode</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-stored-procs">A.4 MySQL 8.0 FAQ: Stored Procedures and Functions</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-triggers">A.5 MySQL 8.0 FAQ: Triggers</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-views">A.6 MySQL 8.0 FAQ: Views</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-information-schema">A.7 MySQL 8.0 FAQ: INFORMATION_SCHEMA</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-migration">A.8 MySQL 8.0 FAQ: Migration</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-security">A.9 MySQL 8.0 FAQ: Security</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-mysql-cluster">A.10 MySQL 8.0 FAQ: MySQL Cluster</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-cjk">A.11 MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-connectors-apis">A.12 MySQL 8.0 FAQ: Connectors &amp; APIs</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-replication">A.13 MySQL 8.0 FAQ: Replication</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-thread-pool">A.14 MySQL 8.0 FAQ: MySQL Enterprise Thread Pool</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-innodb-change-buffer">A.15 MySQL 8.0 FAQ: InnoDB Change Buffer</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-tablespace-encryption">A.16 MySQL 8.0 FAQ: InnoDB Tablespace Encryption</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="faqs.html#faqs-virtualization">A.17 MySQL 8.0 FAQ: Virtualization Support</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="appendix">
            <a href="error-handling.html">B Errors, Error Codes, and Common Problems</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="error-handling.html#error-sources">B.1 Sources of Error Information</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="error-handling.html#error-types">B.2 Types of Error Values</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="error-handling.html#error-messages-server">B.3 Server Error Codes and Messages</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="error-handling.html#error-messages-client">B.4 Client Error Codes and Messages</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="error-handling.html#problems">B.5 Problems and Common Errors</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="error-handling.html#what-is-crashing">B.5.1 How to Determine What Is Causing a Problem</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="error-handling.html#common-errors">B.5.2 Common Errors When Using MySQL Programs</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="error-handling.html#administration-issues">B.5.3 Administration-Related Issues</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="error-handling.html#query-issues">B.5.4 Query-Related Issues</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="error-handling.html#optimizer-issues">B.5.5 Optimizer-Related Issues</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="error-handling.html#table-definition-issues">B.5.6 Table Definition-Related Issues</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="error-handling.html#bugs">B.5.7 Known Issues in MySQL</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="appendix">
            <a href="restrictions.html">C Restrictions and Limits</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="section">
                <a href="restrictions.html#stored-program-restrictions">C.1 Restrictions on Stored Programs</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="restrictions.html#condition-handling-restrictions">C.2 Restrictions on Condition Handling</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="restrictions.html#cursor-restrictions">C.3 Restrictions on Server-Side Cursors</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="restrictions.html#subquery-restrictions">C.4 Restrictions on Subqueries</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="restrictions.html#view-restrictions">C.5 Restrictions on Views</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="restrictions.html#xa-restrictions">C.6 Restrictions on XA Transactions</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="restrictions.html#charset-restrictions">C.7 Restrictions on Character Sets</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="restrictions.html#performance-schema-restrictions">C.8 Restrictions on Performance Schema</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="restrictions.html#pluggable-authentication-restrictions">C.9 Restrictions on Pluggable Authentication</a>
              </span>
            </dt>
            <dt>
              <span class="section">
                <a href="restrictions.html#limits">C.10 Limits in MySQL</a>
              </span>
            </dt>
            <dd>
              <dl>
                <dt>
                  <span class="section">
                    <a href="restrictions.html#joins-limits">C.10.1 Limits on Joins</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="restrictions.html#database-count-limit">C.10.2 Limits on Number of Databases and Tables</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="restrictions.html#table-size-limit">C.10.3 Limits on Table Size</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="restrictions.html#column-count-limit">C.10.4 Limits on Table Column Count and Row Size</a>
                  </span>
                </dt>
                <dt>
                  <span class="section">
                    <a href="restrictions.html#limits-windows">C.10.5 Windows Platform Limitations</a>
                  </span>
                </dt>
              </dl>
            </dd>
          </dl>
        </dd>
        <dt>
          <span class="appendix">
            <a href="indexes.html">D Indexes</a>
          </span>
        </dt>
        <dd>
          <dl>
            <dt>
              <span class="index">
                <a href="ix01.html">General Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-cfunc.html">C Function Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-command.html">Command Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-function.html">Function Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-is.html">INFORMATION_SCHEMA Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-jointype.html">Join Types Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-operator.html">Operator Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-option.html">Option Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-priv.html">Privileges Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-sqlmode.html">SQL Modes Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-statement.html">Statement/Syntax Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-statvar.html">Status Variable Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-sysvar.html">System Variable Index</a>
              </span>
            </dt>
            <dt>
              <span class="index">
                <a href="dynindex-isolevel.html">Transaction Isolation Level Index</a>
              </span>
            </dt>
          </dl>
        </dd>
        <dt>
          <span class="glossary">
            <a href="glossary.html">MySQL Glossary</a>
          </span>
        </dt>
      </dl>
    </div>
    <div class="copyright-footer">

    </div>
    <div class="navfooter">
      <hr>
      <table width="100%" summary="Navigation footer">
        <tr>
          <td width="40%" align="left"></td>
          <td width="20%" align="center">
            <a accesskey="u" href="">Up</a>
          </td>
          <td width="40%" align="right">
            <a accesskey="n" href="preface.html">Next</a>
          </td>
        </tr>
        <tr>
          <td width="40%" align="left" valign="top"></td>
          <td width="20%" align="center">
            <a accesskey="h" href="index.html">Home</a>
          </td>
          <td width="40%" align="right" valign="top"> Preface and Legal Notices</td>
        </tr>
      </table>
    </div>
</body>

</html>